Tabela LServiceTimePattern

Definicja tabeli LServiceTimePattern

Name

LServiceTimePattern

Code

LServiceTimePattern

Comment

PL:Tabelka przechowuje liste uslug na które stworzony jest dany wzorzec.
EN: Table with service list for certain pattern.
DE: Die Tabelle fur die Serviceliste hinsichtlich das Ausfallmuster


Lista kolumn tabeli LServiceTimePattern

Name

Code

ServID

ServID

TimePatternID

TimePatternID


Kolumna ServID tabeli LServiceTimePattern

Definicja kolumny ServID tabeli LServiceTimePattern

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TimePatternID tabeli LServiceTimePattern

Definicja kolumny TimePatternID tabeli LServiceTimePattern

Name

TimePatternID

Code

TimePatternID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Lista kluczy tabeli LServiceTimePattern

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LServiceTimePattern

Definicja klucza Identifier_1 tabeli LServiceTimePattern

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment